export const ResearchGroupMembersQueries = {
    GetResearchGroupMembers: `
    SELECT
      id,
      researchGroupId,
      researchGroupMemberId
    FROM my_schema.research_group_members
    `,
  
    GetResearchGroupMembersById: `
    SELECT
      id,
      researchGroupId,
      researchGroupMemberId
    FROM my_schema.research_group_members
    WHERE
      id = ?
    `,

    GetResearchGroupMembersByGroupId: `
    SELECT
      id,
      researchGroupId,
      researchGroupMemberId
    FROM my_schema.research_group_members
    WHERE
      researchGroupId = ?
    `,
  
    AddResearchGroupMembers: `
    INSERT INTO my_schema.research_group_members (researchGroupId, researchGroupMemberId)
      VALUES ?
    `,
  
    DeleteResearchGroupMembersByGroupId: `
    DELETE FROM my_schema.research_group_members
    WHERE
      researchGroupId = ?
    `
  };